package com.ruoyi.datastatistics.mapper;

import java.math.BigDecimal;
import java.util.List;
import com.ruoyi.datastatistics.domain.PublicShareReport;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

/**
 * 公摊报表Mapper接口
 *
 * @author zt
 * @date 2025-05-27
 */
public interface PublicShareReportMapper extends BaseMapper<PublicShareReport>
{

    List<PublicShareReport> selectTotalReportList(PublicShareReport publicShareReport);

    List<PublicShareReport> selectProductReportList1(PublicShareReport publicShareReport);
    List<PublicShareReport> selectProductReportList2(PublicShareReport publicShareReport);

    BigDecimal selectProductReportList1Sum(PublicShareReport publicShareReport);
    BigDecimal selectProductReportList2Sum(PublicShareReport publicShareReport);



    int insertForElectricityTerminalsForOne(@Param("frequencyType")String frequencyType, @Param("month")String month,@Param("freezeTime") String freezeTime, @Param("userId")String userId);
    int insertForElectricityTerminalsForThree(@Param("frequencyType")String frequencyType, @Param("month")String month,@Param("freezeTime") String freezeTime, @Param("userId")String userId);

    int insertForWaterTerminalsForOne(@Param("frequencyType")String frequencyType, @Param("month")String month,@Param("freezeTime") String freezeTime, @Param("userId")String userId);
    int insertForWaterTerminalsForThree(@Param("frequencyType")String frequencyType, @Param("month")String month,@Param("freezeTime") String freezeTime, @Param("userId")String userId);

}
